<?php
/*
	Copyright 2006, 2007, 2008, 2009, 2010 Bastiaan Grutters
    
    This file is part of Ages of Strife website.

    Ages of Strife website is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    Ages of Strife website is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with Ages of Strife website.  If not, see <http://www.gnu.org/licenses/>.
 */
include( '../global/initialize.php' );

$query = "SELECT expedition_id, name, required, required_level, is_unique FROM expeditions ORDER BY time_cost, name";
$result = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
$num = mysql_numrows( $result );
$status = "";
$i = 0;
$done = false;
while ( $i < $num && !$done ) {
	$expedition_id = mysql_result( $result, $i, "expedition_id" );
	if( isset( $_POST[ "check_" . $expedition_id ] ) && $_POST[ "check_" . $expedition_id ] ) {
		if( isset( $_POST[ "text_" . $expedition_id ] ) ) {
			$amount = $_POST[ "text_" . $expedition_id ];
			
			$repeat = 0;
			if( isset( $_POST[ 'repeat_' . $expedition_id ] ) ) {
				$repeat = 1;
			}
			$p = 0;
			while ( !$done && $p < $amount ) {
				$query = "SELECT count(*) " .
						"FROM ruler_expedition " .
						"WHERE ruler_id = " . $_SESSION[ 'ruler_id' ] . " AND completed = 0";
				$result2 = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
				$row2 = mysql_fetch_array( $result2, MYSQL_ASSOC );
				$total = $row2[ 'count(*)' ];
				if( $total < getQueueLength() ) { 
					$pending = 0;
					if( $total == 0 ) {
						$pending = 1;
					}
					
					$unique = mysql_result( $result, $i, "is_unique" );
					
					$add = true;
					
//					$query2 = "SELECT count(*) FROM colony WHERE ruler_id = " . $_SESSION[ 'ruler_id' ];
//					$result2 = mysql_query( $query2 ) or die( "Query failed : " . mysql_error() );
//					$row2 = mysql_fetch_array( $result2, MYSQL_ASSOC);
//					$colonies = $row2[ 'count(*)' ];
//					
//					if( $colonies >= 3 && ( $expedition_id == 13 || $expedition_id == 14 || $expedition_id == 15 ) ) {
//						$add = false;
//					} 
					
					if( $unique == 1 ) {
						$query = "SELECT count(*) FROM ruler_expedition WHERE expedition_id = " . $expedition_id . " AND ruler_id = " . $_SESSION[ 'ruler_id' ];
						$result2 = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
						$row2 = mysql_fetch_array( $result2, MYSQL_ASSOC );
						if( $row2[ 'count(*)' ] > 0 ) {
							$add = false;
						}						
					}
					if( $add ) {
						if( mysql_result( $result, $i, "required" ) > -1 ) {
							$add = false;
							$query = "SELECT count(*) FROM upgrade_status " .
									"WHERE upgrade_id = " . mysql_result( $result, $i, "required" ) . " " .
									"AND ruler_id = " . $_SESSION[ 'ruler_id' ] . 
									" AND level = " . mysql_result( $result, $i, "required_level" );
							$result2 = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
							$row2 = mysql_fetch_array( $result2, MYSQL_ASSOC );						
							if( $row2[ 'count(*)' ] > 0 ) {
								$add = true;
							}						
						}
						
						if( $add ) {
							$query = "INSERT INTO ruler_expedition ( ruler_id, expedition_id, rank, pending, `repeat` ) " .
									"VALUES ( " . $_SESSION[ 'ruler_id' ] . ", $expedition_id, $total, $pending, $repeat )";
							mysql_query( $query ) or die( "Query failed : " . mysql_error() );
						}
						else {
							$status = translate( "Can't add" ) . " " . mysql_result( $result, $i, "name" ) . ", " . translate( "you don't have the required upgrades" ) . ".";
						}
					}
					else {
						$status = translate( "Can't add" ) . " " . mysql_result( $result, $i, "name" ) . ", " . translate( "you already have it" ) . ".";
					}
				}
				else {
					$done = true;
					$status = translate( "Your expedition queue is full." );
				}
				$p ++;
			}
		}
	}
	$i ++;
}
if( $status != "" ) $_SESSION[ 'que_expedition_status' ] = $status;
header( "Location: expeditions.php" );
?>
